/**
 * @Description:
 * @Author: Administrator
 * @Date: 2020-11-5 16:03
 */
package org.jsola.hr.constant;

import java.util.HashMap;
import java.util.Map;

public class StatisticsPageColumn {
    public static final Map<String, String> headNameMap = new HashMap<String, String>(){
        private static final long serialVersionUID = 1L;
        {
                put("name", "姓名");
                put("phone", "手机号");
                put("employType","员工类型");
                put("isImprove","信息补充(必填);");
                put("verified","实名认证");
                put("companyName","用工单位");
                put("idCard","身份证号码");
                put("gender","性别");
                put("birthday","出生日期");
                put("empAge","年龄");
                put("maritalStatus","婚姻状况");
                put("birthStatus","生育状况");
                put("nation","民族");
                put("politicalStatus","政治面貌");
                put("regType","户口性质");
                put("nativeLocation","户籍地址");
                put("bloodGroup","血型");
                put("email","个人邮箱");
                put("currentLocation","现居住地");
                put("highestEducation","学历");
                put("degreeType","学位");
                put("graCollege","毕业院校");
                put("major","毕业专业");
                put("teaMethods","学习形式");
                put("contactsName","紧急联系人姓名");
                put("contactsPhone","紧急联系人电话");
                put("contactsRelation","紧急联系人与我的关系");
                put("contactsAddress","紧急联系人地址");
                put("bankCard","工资卡卡号");
                put("bankName","银行名称");
                put("bankPlace","工资卡开户城市");
                put("bankCardBranch","工资卡开户支行");
                put("socCard","个人社保账号");
                put("pfCard","个人公积金账号");
        }

    };

        public static final Map<String, String> EXPORT_COLUMN_NAME_MAP = new HashMap<String, String>() {
                private static final long serialVersionUID = 1L;
                {
                        put("id", "e.id as id");
                        put("companyId", "e.company_id as companyId");
                        put("name", "e.name as name");
                        put("phone", "e.phone as phone");
                        put("joinDate", "DATE_FORMAT(e.join_date,\"%Y-%m-%d\") as joinDate");
                        put("employType","CASE e.employ_type WHEN 1 THEN '正式' ELSE '非正式' END as employType");
                        put("isImprove"," CASE e.is_improve WHEN 1 THEN '完善' ELSE '未完善' END as isImprove");
                        put("verified","CASE e.verified  WHEN 1 THEN '已认证' ELSE '未认证' END as verified");
                        put("companyName","co.`name` as companyName");
                        put("idCard","e.id_card as idCard");
                        put("gender","CASE e.gender   WHEN 1 THEN '男' ELSE '女' END as gender");
                        put("birthday","DATE_FORMAT(e.birthday,\"%Y-%m-%d\")  as birthday");
                        put("empAge","e.emp_age as empAge");
                        put("maritalStatus","CASE e.marital_status WHEN 1 THEN '已婚' WHEN 2 THEN '未婚' " +
                                "WHEN 3 THEN '离异' ELSE '' END as maritalStatus");
                        put("birthStatus","CASE e.birth_status   WHEN 1 THEN '已育' WHEN 2 THEN '未生育' " +
                                "ELSE '' END as birthStatus");
                        put("nation","e.nation as nation");
                        put("politicalStatus","CASE e.political_status  WHEN 1 THEN '中共党员' WHEN 2 THEN '共青团员' " +
                                "WHEN 3 THEN '普通居民/群众' WHEN 4 THEN '其他' WHEN 5 THEN '积极分子' WHEN 6 THEN '预备党员' " +
                                "ELSE '' END as politicalStatus");
                        put("regType","CASE e.reg_type  WHEN 1 THEN '城镇户口' WHEN 2 THEN '农村户口' " +
                                "WHEN 3 THEN '居民户口' ELSE '' END as regType");
                        put("nativeLocation","e.native_location as nativeLocation");
                        put("bloodGroup","CASE e.blood_group  WHEN 1 THEN 'A' WHEN 2 THEN 'B' WHEN 3 THEN 'AB' " +
                                "WHEN 4 THEN 'O' ELSE '' END as bloodGroup");
                        put("email","e.email as email");
                        put("contractSubject", "e.contract_subject as contractSubject");
                        put("currentLocation","e.current_location as currentLocation");
                        put("highestEducation","CASE ee.education WHEN 1 THEN '小学' WHEN 2 THEN '初中' " +
                                "WHEN 3 THEN '中专' WHEN 4 THEN '高中' WHEN 5 THEN '大专' WHEN 6 THEN '本科' " +
                                "WHEN 7 THEN '硕士' WHEN 8 THEN '博士' WHEN 9 THEN '其他' ELSE '' END as highestEducation");
                        put("degreeType","CASE ee.degree_type WHEN 1 THEN '学士' WHEN 2 THEN '硕士' " +
                                "WHEN 3 THEN '博士' ELSE '' END as degreeType");
                        put("graCollege","ee.gra_college as graCollege");
                        put("major","ee.major as major");
                        put("teaMethods","CASE ee.tea_methods  WHEN 1 THEN '全日制' WHEN 2 THEN '成人教育' " +
                                "WHEN 3 THEN '远程教育' WHEN 4 THEN '自学考试' ELSE '' END as teaMethods");
                        put("contactsName","ec.contactsName AS contactsName");
                        put("contactsPhone","ec.contactsPhone AS contactsPhone");
                        put("contactsRelation","ec.contactsRelation AS contactsRelation");
                        put("contactsAddress","ec.contactsAddress AS contactsAddress");
                        put("bankCard","e.bank_card as bankCard");
                        put("bankName","e.bank_name as bankName");
                        put("bankPlace","e.bank_place as bankPlace");
                        put("bankCardBranch"," e.bank_card_branch as bankCardBranch");
                        put("socCard","e.soc_card as socCard");
                        put("pfCard","e.pf_card as pfCard");
                        put("formalType"," CASE e.formal_type WHEN 1 THEN '试用' WHEN 2 THEN '正式' ELSE '无状态' END  as formalType");
                        put("remark"," e.remark as remark");
                        put("channelName"," c.name as channelName");
                        put("tag"," e.tag as tag");
//                        put("postType"," CASE e.post_type WHEN 1 THEN '劳务派遣' WHEN 2 THEN '外包' " +
//                                "WHEN 3 THEN '社保代缴' WHEN 4 THEN '薪资代发' WHEN 5 THEN '其他' ELSE '' END  as postType");
                        put("postType"," CONCAT(e.post_type,'')  as postType");
                        put("contractsStatus"," CASE e.contracts_status WHEN 0 THEN '合同未发起' WHEN 1 THEN '待员工签署'" +
                                " WHEN 2 THEN '待公司签署' WHEN 3 THEN '签署完成' WHEN -1 THEN '合同过期未签署'" +
                                " ELSE '' END as contractsStatus");
                        put("depName","GROUP_CONCAT(DISTINCT(de.name)) as depName");
                        put("positionName","GROUP_CONCAT(DISTINCT(pi.name)) as positionName");

                        // 合同相关信息
                        put("contractStartTime","");
                        put("contractEndTime","");
                        put("contactsTerm","");
                        put("contractType","");
                }

        };
}
